Load Data into Power BI Desktop 7
Step-1 Load Data into Power BI Desktop
Use This Info to connect with Server
SQL Server Connection
Server: hypv8669.hostedbyappliedi.net
Username: ColaberryPowerBIReporting
pw: Colaberry99
Database Name:
ColaberryPowerBIReporting
=>TierII_CAP &
=> TierII_CAP_Active
5.Click on the Load button to load the data into Power BI Desktop.
Calendar Table DAX
CALENDAR = ADDCOLUMNS( CALENDAR("1-January-2018",TODAY()), "Year", YEAR([Date]), "Monthnumber",MONTH([Date]), "MonthNameShort", FORMAT ( [Date], "mmm" ), "MonthNameLong",FORMAT ( [Date], "mmmm" ), "DayOfWeekNumber", WEEKDAY ( [Date] ), "DayOfWeek", FORMAT ( [Date], "dddd" ), "DayOfWeekShort",FORMAT ( [Date], "ddd" ), "Quarter", "Q" & FORMAT ( [Date], "Q"), "Year Quarter Name", FORMAT ( [Date], "YYYY" ) & "-Q" & FORMAT ( [Date], "Q"), "Year Quarter Number", YEAR( [Date]) * 100 + QUARTER( [Date]), "Year Month Name", FORMAT( [Date], "mmm") & " " & YEAR( [Date]), |
To learn more about how to get data in power bi desktop , click below:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-desktop-files